<%@ page language="java"%>
<%@ page import="com.database.DataBase" %>

<html>
  <head>
   
    <title>My JSP 'VipCardSub.jsp' starting page</title>
   
  </head>
  
  <body>
   <%request.setCharacterEncoding("gbk");
         String VipID=request.getParameter("VipID");
         
  
        String wintypeid=request.getParameter("wintypeid");
        String EnableSms=request.getParameter("EnableSms");
        String CardDesc=request.getParameter("CardDesc");
         
         String branchID="1";//request.getSession().getAttribute("branchNO").toString();
         
         DataBase base=new DataBase();
         String sql="update cardlist set wintypeid='"+wintypeid+"',EnableSms='"+EnableSms+"',CardDesc='"+CardDesc+"' where VipID='"+VipID+"'";
         System.out.println(sql);
         base.executeUpdate(sql);
         base.closeStmt();
         base.closeConn();
         response.sendRedirect("Vipdjset.jsp?branchID="+branchID+"");
   %>
  </body>
</html>
